Release 10.1A: OpenEdge Getting Started:
New and Revised Features

SQL

OpenEdge Release 10.1A includes the following SQL enhancements:

Support for auditing, including the:
Addition of AUDIT INSERT and AUDIT SET statements.
Ability to grant and revoke audit privileges.
The ability to set Progress 4GL table and column attributes using ALTER TABLE, CREATE TABLE, and CREATE INDEX.
The ability to create active indexes using the CREATE INDEX statement.
The ability to run the following statements against an online database:
ALTER TABLE ADD COLUMN
CREATE VIEW
CREATE PROCEDURE
CREATE TRIGGER
SET PRO_SERVER LOG and SET PRO_CONNECT LOG, which allow you to control logging for SQL Servers.
The removal of the SQL_WIDTH limitation on the SUBSTR and SUBSTRING functions.
Support for the ARRAY data type.
The VARARRAY data type, which allows its elements’ values to exceed the declared size while the total size is limited by SQL_WIDTH.
Support for the Java Transaction API (JTA), which allows applications to perform distributed transactions.
ODBC driver with Unicode support.
Type 4 JDBC driver.

For more information, see:

Manuals:

OpenEdge Data Management: SQL Development OpenEdge Data Management: SQL Reference